You can convert the entity object to list Object by looping the LINQ Query results and adding the object to the list.
The following example code clears how to convert to List Object
public ActionResult GetChart()
{
List<object>chartData = new List<object>();
chartData.Add(new object[]{
"ShipCity", "TotalOrders"
});
var result = (from order in db.Orders.AsEnumerable()
group order by order.ShipCity into rowGroup
select new
{
ShipCity =rowGroup.Key,
TotalOrders =rowGroup.Count()
}).Distinct().ToList();
foreach (var c in result)
{
chartData.Add(new object[]
{
c.ShipCity, c.TotalOrders
});
}
return new JsonResult
{
Data = new
{
success = chartData,
message = "Success",
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
};
}
Output:
Post your comments / questions
Recent Article
- The request was aborted: Could not create SSL/TLS secure channel -Error in Asp.net
- FieldError: Cannot resolve keyword 'id' into field in Django project
- How to hide the ID field from the Django admin?
- It is impossible to add a non nullable field without specifying a default. Django error
- ImportError: cannot import name 'url' from 'django.conf.urls' - Django Error
- How to Enable Virtualization in BIOS Security Settings in Intel Processors For Android Studio?
- Dependency 'androidx.activity:activity:1.8.0' requires libraries and applications that depend on it.
- AttributeError: 'NoneType' object has no attribute 'get_text' - Python
Related Article